package com.ws.ssmzongjie3.mapper;

import com.ws.ssmzongjie3.bean.Column;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ColumnMapper {
    @Select("select column_name from columns where column_id=#{column_id}")
    public String getColumnName(Column column);
    @Insert("insert into columns(column_name,column_status,column_desc,column_order,create_time) values(#{column_name},0,#{column_desc},#{column_order},now())")
    public void insertColumn(Column column);
    @Delete("delete from columns where column_id=#{column_id}")
    public void deleteColumn(Column column);
    @Select("select * from columns where column_id=#{column_id}")
    public Column getColumnById(Column column);
    public void updateColumn(Column column);
    public List<Column> listColumn(Column column);

}
